概要

Database administrator (DBA) with extensive experience of designing, coding, testing and supporting next-generation database solutions in Oracle enterprise and SQL development environments. Oracle ApplicationsDBA with hands on in administering Oracle Databases, Tools and ERP Applications. Proficient in an assortment of technologies. An experienced IT professional with database & Unix administration skills across Oracle. 

工作经历

公司标识
Senior Database Administrator/ Oracle Apps DBA
Kashf Foundation Lahore
Jun 2019 - 代表 | Lahore, Pakistan

Oracle ERP Database maintenance and support.  Oracle ERP patching, Cloning, AdAdmin, Backup/Recovery and User Management etc  Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.  Query optimization and creation according to the requirement.  Performing database backup and recovery.  Perform database monitoring/maintenance tasks on daily basis.  Implemented database refresh using full export for table level and full database defragmentation, resulting improved performance and effective space management.  Provides technical support to application development teams. 
 

公司标识
Senior Database Administrator
Inov8 limited
May 2014 - Jun 2019 | Lahore, Pakistan

• Creation and maintenance of all databases required for development, testing and production usage.
• Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
• Query optimization of hibernate and reports and also reports creation and maintenance.
• Perform database monitoring tasks on daily basis.
• Implemented database refresh using full export for table level and full database defragmentation, resulting improved performance and effective space management.
• Provides technical support to application development teams.
• Troubleshoots with problems regarding the databases, applications and development.
• Database performance tuning and segmentation.
• Create new database users and also migrate in different databases.
• RAC and RMAN Backup operations and administration.




Projects:

• PAYMAX Branchless banking by Zong and Askrai Bank.
• JS Branchless banking by JS Bank.
• BOP Branchless banking by BOP Bank.
• Soneri Branchless banking by Soneri Bank.
• FonePay
• JS Mobile banking by JS Bank.
• BOP Mobile banking by BOP Bank.

公司标识
Billing & Commercial Officer
4B Gentel International Pvt. Ltd.
Feb 2012 - May 2014 | Lahore, Pakistan

• Monitor Billing application regarding CDRs Mediation, CDRs Rating and rerating, CDRs verification, Billing Invoices and Invoices verification and all kind of Reports.

• Manage the Backup of Databases and Switch Data. Work on backend layer and write stored procedures, views and triggers to implement business logic.
• Design and develop reports using VB.Net and SQL Server 2008.

• Coordinating with engineering team and Billing Solution providers.
• Develop queries for new analysis and updating existing queries for better performance.

• Monitoring the Minutes difference in Billing CDRs and Switch CDRs.

学历

COMSATS Institute of Information Technology
Bachelors in Engineering, Bachelor of Science in Computer Engineering‎
Digital Signal Processing, Communication and Digital Signal Processing, Programming
所占比重 70%
2009

技能

中级 Datacom/DB
熟练 Monitoring
熟练 Oracle admin
熟练 Oracle Administration
中级 Oracle Apps DBA
熟练 Oracle Database Administration
熟练 Performance Tuning